To develop the external transit tables for the MTP scenarios – 2030-40-50 – the script (“ExtTransitTrips.rsc”) developed by Joe Schirripa for automating the task is used. Previously the script was used to develop the 2045 external transit tables be Mei Ingram.

Using the script requires editing the TRMv6_ExtTransit_Paremeters excel worksheet. Developed by Mei using 2005 TOB data and 2013 SE ADT data (ADT, PctCV, AutoEE) this worksheet leads a step by step process to develop the two parameters needed in order to run the script. The worksheet is saved in the scenario/Input/Parameters during the execution of the script.

  1. First parameter is called “pctTransitAV”, with a tab of the same name. Mei calculated the 2013 version on the tab “Ref_TOB_2005_2013”, column J. Input comes from the SE file for ADT, PctCV, PctAutoEE, and the transit trip EI totals. Values are pasted into the aforementioned tab and read by script. 2016 calculation is found starting at J29 in “JF_pctTransitAV_2016” tab.
  2. Second parameter, “pctTransitMode” reads in the external transit matrix by trip type (Local/Express and PnR/KnR) and time (PK/OP). Mei’s calculation is shown in column AK in same “Ref_TOB_2005_2013” tab.
  1. PK/OP_Trip# tabs – Input data from the 2013 external transit trip table by trip type, with the percentage share for each external TAZ’s destination by internal TAZ. No need to modify for this task.

Both parameters are calculated for the base year (2016) and is used to create future scenario external transit tables, i.e. 2030, 2040, 2050. Hence no need to create parameters other than for 2016. Note both parameters currently saved in the TRMv6_ExtTransit_Parameters are the updated 2016 values, not Mei’s original 2013 values.

Simply updating the EE_EI_IE 20xx matrix file being read in the script will result in the corresponding external transit table being produced. See below for a snip of the script to create the 2050 external transit table.